package com.ttj.domain.oracle.gen;

import java.util.ArrayList;
import java.util.List;

public class OrderPurchaseDetailCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer mysqlOffset;

    protected Integer mysqlLength;

    public OrderPurchaseDetailCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlOffset(Integer mysqlOffset) {
        this.mysqlOffset=mysqlOffset;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlOffset() {
        return mysqlOffset;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlLength(Integer mysqlLength) {
        this.mysqlLength=mysqlLength;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlLength() {
        return mysqlLength;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("ORDER_ID is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("ORDER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Integer value) {
            addCriterion("ORDER_ID =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Integer value) {
            addCriterion("ORDER_ID <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Integer value) {
            addCriterion("ORDER_ID >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ORDER_ID >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Integer value) {
            addCriterion("ORDER_ID <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Integer value) {
            addCriterion("ORDER_ID <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Integer> values) {
            addCriterion("ORDER_ID in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Integer> values) {
            addCriterion("ORDER_ID not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_ID between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_ID not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andGIdIsNull() {
            addCriterion("G_ID is null");
            return (Criteria) this;
        }

        public Criteria andGIdIsNotNull() {
            addCriterion("G_ID is not null");
            return (Criteria) this;
        }

        public Criteria andGIdEqualTo(Integer value) {
            addCriterion("G_ID =", value, "gId");
            return (Criteria) this;
        }

        public Criteria andGIdNotEqualTo(Integer value) {
            addCriterion("G_ID <>", value, "gId");
            return (Criteria) this;
        }

        public Criteria andGIdGreaterThan(Integer value) {
            addCriterion("G_ID >", value, "gId");
            return (Criteria) this;
        }

        public Criteria andGIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("G_ID >=", value, "gId");
            return (Criteria) this;
        }

        public Criteria andGIdLessThan(Integer value) {
            addCriterion("G_ID <", value, "gId");
            return (Criteria) this;
        }

        public Criteria andGIdLessThanOrEqualTo(Integer value) {
            addCriterion("G_ID <=", value, "gId");
            return (Criteria) this;
        }

        public Criteria andGIdIn(List<Integer> values) {
            addCriterion("G_ID in", values, "gId");
            return (Criteria) this;
        }

        public Criteria andGIdNotIn(List<Integer> values) {
            addCriterion("G_ID not in", values, "gId");
            return (Criteria) this;
        }

        public Criteria andGIdBetween(Integer value1, Integer value2) {
            addCriterion("G_ID between", value1, value2, "gId");
            return (Criteria) this;
        }

        public Criteria andGIdNotBetween(Integer value1, Integer value2) {
            addCriterion("G_ID not between", value1, value2, "gId");
            return (Criteria) this;
        }

        public Criteria andNumIsNull() {
            addCriterion("NUM is null");
            return (Criteria) this;
        }

        public Criteria andNumIsNotNull() {
            addCriterion("NUM is not null");
            return (Criteria) this;
        }

        public Criteria andNumEqualTo(Integer value) {
            addCriterion("NUM =", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotEqualTo(Integer value) {
            addCriterion("NUM <>", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumGreaterThan(Integer value) {
            addCriterion("NUM >", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("NUM >=", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumLessThan(Integer value) {
            addCriterion("NUM <", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumLessThanOrEqualTo(Integer value) {
            addCriterion("NUM <=", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumIn(List<Integer> values) {
            addCriterion("NUM in", values, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotIn(List<Integer> values) {
            addCriterion("NUM not in", values, "num");
            return (Criteria) this;
        }

        public Criteria andNumBetween(Integer value1, Integer value2) {
            addCriterion("NUM between", value1, value2, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotBetween(Integer value1, Integer value2) {
            addCriterion("NUM not between", value1, value2, "num");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("PRICE is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(Double value) {
            addCriterion("PRICE =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(Double value) {
            addCriterion("PRICE <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(Double value) {
            addCriterion("PRICE >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("PRICE >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(Double value) {
            addCriterion("PRICE <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(Double value) {
            addCriterion("PRICE <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<Double> values) {
            addCriterion("PRICE in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<Double> values) {
            addCriterion("PRICE not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(Double value1, Double value2) {
            addCriterion("PRICE between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(Double value1, Double value2) {
            addCriterion("PRICE not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andTpriceIsNull() {
            addCriterion("TPRICE is null");
            return (Criteria) this;
        }

        public Criteria andTpriceIsNotNull() {
            addCriterion("TPRICE is not null");
            return (Criteria) this;
        }

        public Criteria andTpriceEqualTo(Double value) {
            addCriterion("TPRICE =", value, "tprice");
            return (Criteria) this;
        }

        public Criteria andTpriceNotEqualTo(Double value) {
            addCriterion("TPRICE <>", value, "tprice");
            return (Criteria) this;
        }

        public Criteria andTpriceGreaterThan(Double value) {
            addCriterion("TPRICE >", value, "tprice");
            return (Criteria) this;
        }

        public Criteria andTpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("TPRICE >=", value, "tprice");
            return (Criteria) this;
        }

        public Criteria andTpriceLessThan(Double value) {
            addCriterion("TPRICE <", value, "tprice");
            return (Criteria) this;
        }

        public Criteria andTpriceLessThanOrEqualTo(Double value) {
            addCriterion("TPRICE <=", value, "tprice");
            return (Criteria) this;
        }

        public Criteria andTpriceIn(List<Double> values) {
            addCriterion("TPRICE in", values, "tprice");
            return (Criteria) this;
        }

        public Criteria andTpriceNotIn(List<Double> values) {
            addCriterion("TPRICE not in", values, "tprice");
            return (Criteria) this;
        }

        public Criteria andTpriceBetween(Double value1, Double value2) {
            addCriterion("TPRICE between", value1, value2, "tprice");
            return (Criteria) this;
        }

        public Criteria andTpriceNotBetween(Double value1, Double value2) {
            addCriterion("TPRICE not between", value1, value2, "tprice");
            return (Criteria) this;
        }

        public Criteria andInsStatusIsNull() {
            addCriterion("INS_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andInsStatusIsNotNull() {
            addCriterion("INS_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andInsStatusEqualTo(Integer value) {
            addCriterion("INS_STATUS =", value, "insStatus");
            return (Criteria) this;
        }

        public Criteria andInsStatusNotEqualTo(Integer value) {
            addCriterion("INS_STATUS <>", value, "insStatus");
            return (Criteria) this;
        }

        public Criteria andInsStatusGreaterThan(Integer value) {
            addCriterion("INS_STATUS >", value, "insStatus");
            return (Criteria) this;
        }

        public Criteria andInsStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("INS_STATUS >=", value, "insStatus");
            return (Criteria) this;
        }

        public Criteria andInsStatusLessThan(Integer value) {
            addCriterion("INS_STATUS <", value, "insStatus");
            return (Criteria) this;
        }

        public Criteria andInsStatusLessThanOrEqualTo(Integer value) {
            addCriterion("INS_STATUS <=", value, "insStatus");
            return (Criteria) this;
        }

        public Criteria andInsStatusIn(List<Integer> values) {
            addCriterion("INS_STATUS in", values, "insStatus");
            return (Criteria) this;
        }

        public Criteria andInsStatusNotIn(List<Integer> values) {
            addCriterion("INS_STATUS not in", values, "insStatus");
            return (Criteria) this;
        }

        public Criteria andInsStatusBetween(Integer value1, Integer value2) {
            addCriterion("INS_STATUS between", value1, value2, "insStatus");
            return (Criteria) this;
        }

        public Criteria andInsStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("INS_STATUS not between", value1, value2, "insStatus");
            return (Criteria) this;
        }

        public Criteria andInsNumsIsNull() {
            addCriterion("INS_NUMS is null");
            return (Criteria) this;
        }

        public Criteria andInsNumsIsNotNull() {
            addCriterion("INS_NUMS is not null");
            return (Criteria) this;
        }

        public Criteria andInsNumsEqualTo(Integer value) {
            addCriterion("INS_NUMS =", value, "insNums");
            return (Criteria) this;
        }

        public Criteria andInsNumsNotEqualTo(Integer value) {
            addCriterion("INS_NUMS <>", value, "insNums");
            return (Criteria) this;
        }

        public Criteria andInsNumsGreaterThan(Integer value) {
            addCriterion("INS_NUMS >", value, "insNums");
            return (Criteria) this;
        }

        public Criteria andInsNumsGreaterThanOrEqualTo(Integer value) {
            addCriterion("INS_NUMS >=", value, "insNums");
            return (Criteria) this;
        }

        public Criteria andInsNumsLessThan(Integer value) {
            addCriterion("INS_NUMS <", value, "insNums");
            return (Criteria) this;
        }

        public Criteria andInsNumsLessThanOrEqualTo(Integer value) {
            addCriterion("INS_NUMS <=", value, "insNums");
            return (Criteria) this;
        }

        public Criteria andInsNumsIn(List<Integer> values) {
            addCriterion("INS_NUMS in", values, "insNums");
            return (Criteria) this;
        }

        public Criteria andInsNumsNotIn(List<Integer> values) {
            addCriterion("INS_NUMS not in", values, "insNums");
            return (Criteria) this;
        }

        public Criteria andInsNumsBetween(Integer value1, Integer value2) {
            addCriterion("INS_NUMS between", value1, value2, "insNums");
            return (Criteria) this;
        }

        public Criteria andInsNumsNotBetween(Integer value1, Integer value2) {
            addCriterion("INS_NUMS not between", value1, value2, "insNums");
            return (Criteria) this;
        }

        public Criteria andTrateIsNull() {
            addCriterion("TRATE is null");
            return (Criteria) this;
        }

        public Criteria andTrateIsNotNull() {
            addCriterion("TRATE is not null");
            return (Criteria) this;
        }

        public Criteria andTrateEqualTo(Double value) {
            addCriterion("TRATE =", value, "trate");
            return (Criteria) this;
        }

        public Criteria andTrateNotEqualTo(Double value) {
            addCriterion("TRATE <>", value, "trate");
            return (Criteria) this;
        }

        public Criteria andTrateGreaterThan(Double value) {
            addCriterion("TRATE >", value, "trate");
            return (Criteria) this;
        }

        public Criteria andTrateGreaterThanOrEqualTo(Double value) {
            addCriterion("TRATE >=", value, "trate");
            return (Criteria) this;
        }

        public Criteria andTrateLessThan(Double value) {
            addCriterion("TRATE <", value, "trate");
            return (Criteria) this;
        }

        public Criteria andTrateLessThanOrEqualTo(Double value) {
            addCriterion("TRATE <=", value, "trate");
            return (Criteria) this;
        }

        public Criteria andTrateIn(List<Double> values) {
            addCriterion("TRATE in", values, "trate");
            return (Criteria) this;
        }

        public Criteria andTrateNotIn(List<Double> values) {
            addCriterion("TRATE not in", values, "trate");
            return (Criteria) this;
        }

        public Criteria andTrateBetween(Double value1, Double value2) {
            addCriterion("TRATE between", value1, value2, "trate");
            return (Criteria) this;
        }

        public Criteria andTrateNotBetween(Double value1, Double value2) {
            addCriterion("TRATE not between", value1, value2, "trate");
            return (Criteria) this;
        }

        public Criteria andExpriceIsNull() {
            addCriterion("EXPRICE is null");
            return (Criteria) this;
        }

        public Criteria andExpriceIsNotNull() {
            addCriterion("EXPRICE is not null");
            return (Criteria) this;
        }

        public Criteria andExpriceEqualTo(Double value) {
            addCriterion("EXPRICE =", value, "exprice");
            return (Criteria) this;
        }

        public Criteria andExpriceNotEqualTo(Double value) {
            addCriterion("EXPRICE <>", value, "exprice");
            return (Criteria) this;
        }

        public Criteria andExpriceGreaterThan(Double value) {
            addCriterion("EXPRICE >", value, "exprice");
            return (Criteria) this;
        }

        public Criteria andExpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("EXPRICE >=", value, "exprice");
            return (Criteria) this;
        }

        public Criteria andExpriceLessThan(Double value) {
            addCriterion("EXPRICE <", value, "exprice");
            return (Criteria) this;
        }

        public Criteria andExpriceLessThanOrEqualTo(Double value) {
            addCriterion("EXPRICE <=", value, "exprice");
            return (Criteria) this;
        }

        public Criteria andExpriceIn(List<Double> values) {
            addCriterion("EXPRICE in", values, "exprice");
            return (Criteria) this;
        }

        public Criteria andExpriceNotIn(List<Double> values) {
            addCriterion("EXPRICE not in", values, "exprice");
            return (Criteria) this;
        }

        public Criteria andExpriceBetween(Double value1, Double value2) {
            addCriterion("EXPRICE between", value1, value2, "exprice");
            return (Criteria) this;
        }

        public Criteria andExpriceNotBetween(Double value1, Double value2) {
            addCriterion("EXPRICE not between", value1, value2, "exprice");
            return (Criteria) this;
        }

        public Criteria andStockIdIsNull() {
            addCriterion("STOCK_ID is null");
            return (Criteria) this;
        }

        public Criteria andStockIdIsNotNull() {
            addCriterion("STOCK_ID is not null");
            return (Criteria) this;
        }

        public Criteria andStockIdEqualTo(Integer value) {
            addCriterion("STOCK_ID =", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdNotEqualTo(Integer value) {
            addCriterion("STOCK_ID <>", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdGreaterThan(Integer value) {
            addCriterion("STOCK_ID >", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("STOCK_ID >=", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdLessThan(Integer value) {
            addCriterion("STOCK_ID <", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdLessThanOrEqualTo(Integer value) {
            addCriterion("STOCK_ID <=", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdIn(List<Integer> values) {
            addCriterion("STOCK_ID in", values, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdNotIn(List<Integer> values) {
            addCriterion("STOCK_ID not in", values, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdBetween(Integer value1, Integer value2) {
            addCriterion("STOCK_ID between", value1, value2, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdNotBetween(Integer value1, Integer value2) {
            addCriterion("STOCK_ID not between", value1, value2, "stockId");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table ORDER_PURCHASE_DETAIL
     *
     * @mbg.generated do_not_delete_during_merge Wed Jul 12 08:41:20 CST 2017
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}